<?php

/* 
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
require ('db_conn.php');//包含连接文件
require ('function.php');
//取服务类别
$typeid=  isset($_GET['tid'])?$_GET['tid']:-1;
if ($typeid==-1)
    $sql="select a.*,b.typename from db_service a,db_servicetype b where a.txt=b.id";
else 
    $sql="select a.*,b.typename from db_service a,db_servicetype b where a.txt=b.id and a.typeid=$typeid";//查询数据
    $newsrs=$db->query($sql);//执行语句    $rs是一个结果集
    $newsrows=$newsrs->fetch_all(MYSQLI_BOTH);   //包括所有行*/
  
    
    require 'service_html.php';
   //释放结果集
 //  $result->free();
   //关闭数据库
   $db->close();
